Excel Example

Frequency Polygon

Step 1: Enter your frequency table as midpoints in one column and frequency in another.

excel frequency polygon example step 1

Step 2: Select "insert" in the top menu and highlight your data by clicking and dragging.

excel frequency polygon example step 2

Step 3: Select "scatter" from the top menu

excel frequency polygon example step 3

Step 4: Select scatter plot with straight lines

excel frequency polygon example step 4

Step 5: right click graph the select "format" for more options

excel frequency polygon example step 5

Step 6: You may need to change where the the \(x\) or \(y\) axis starts or begins to make a cleaner picture, you can also change the size and color of the dots etc.

excel frequency polygon example step 6

If you want to see this done watch the following video: